Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 999 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 101.6 KiB |
| Average record size in memory | 104.1 B |
Variable types
| Numeric | 6 |
|---|---|
| Categorical | 6 |
| Text | 1 |
Country has constant value "" | Constant |
Category is highly overall correlated with Sub-Category | High correlation |
Discount is highly overall correlated with Profit | High correlation |
Postal Code is highly overall correlated with Region and 1 other fields | High correlation |
Profit is highly overall correlated with Discount | High correlation |
Region is highly overall correlated with Postal Code and 1 other fields | High correlation |
State is highly overall correlated with Postal Code and 1 other fields | High correlation |
Sub-Category is highly overall correlated with Category | High correlation |
Row ID is uniformly distributed | Uniform |
Row ID has unique values | Unique |
Discount has 462 (46.2%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-14 08:31:45.796750 |
|---|---|
| Analysis finished | 2024-02-14 08:31:52.538966 |
| Duration | 6.74 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
Row ID
Real number (ℝ)
UNIFORM  UNIQUE 
| Distinct | 999 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 500 |
| Minimum | 1 |
|---|---|
| Maximum | 999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 50.9 |
| Q1 | 250.5 |
| median | 500 |
| Q3 | 749.5 |
| 95-th percentile | 949.1 |
| Maximum | 999 |
| Range | 998 |
| Interquartile range (IQR) | 499 |
Descriptive statistics
| Standard deviation | 288.53076 |
|---|---|
| Coefficient of variation (CV) | 0.57706152 |
| Kurtosis | -1.2 |
| Mean | 500 |
| Median Absolute Deviation (MAD) | 250 |
| Skewness | 0 |
| Sum | 499500 |
| Variance | 83250 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | 0.1% |
| 672 | 1 | 0.1% |
| 659 | 1 | 0.1% |
| 660 | 1 | 0.1% |
| 661 | 1 | 0.1% |
| 662 | 1 | 0.1% |
| 663 | 1 | 0.1% |
| 664 | 1 | 0.1% |
| 665 | 1 | 0.1% |
| 666 | 1 | 0.1% |
| Other values (989) | 989 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 999 | 1 | |
| 998 | 1 | |
| 997 | 1 | |
| 996 | 1 | |
| 995 | 1 | |
| 994 | 1 | |
| 993 | 1 | |
| 992 | 1 | |
| 991 | 1 | |
| 990 | 1 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.7937938 |
| Min length | 8 |
Characters and Unicode
| Total characters | 8785 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Corporate |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 546 | |
| Corporate | 283 | |
| Home Office | 170 | 17.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 546 | |
| corporate | 283 | |
| home | 170 | 14.5% |
| office | 170 | 14.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1282 | |
| e | 1169 | |
| r | 1112 | |
| C | 829 | |
| m | 716 | |
| n | 546 | 6.2% |
| s | 546 | 6.2% |
| u | 546 | 6.2% |
| f | 340 | 3.9% |
| t | 283 | 3.2% |
| Other values (7) | 1416 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7446 | |
| Uppercase Letter | 1169 | 13.3% |
| Space Separator | 170 | 1.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 1282 | |
| e | 1169 | |
| r | 1112 | |
| m | 716 | |
| n | 546 | |
| s | 546 | |
| u | 546 | |
| f | 340 | 4.6% |
| t | 283 | 3.8% |
| p | 283 | 3.8% |
| Other values (3) | 623 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 829 | |
| H | 170 | 14.5% |
| O | 170 | 14.5% |
Space Separator
| Value | Count | Frequency (%) |
| 170 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8615 | |
| Common | 170 | 1.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 1282 | |
| e | 1169 | |
| r | 1112 | |
| C | 829 | |
| m | 716 | |
| n | 546 | |
| s | 546 | |
| u | 546 | |
| f | 340 | 3.9% |
| t | 283 | 3.3% |
| Other values (6) | 1246 |
Common
| Value | Count | Frequency (%) |
| 170 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8785 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 1282 | |
| e | 1169 | |
| r | 1112 | |
| C | 829 | |
| m | 716 | |
| n | 546 | 6.2% |
| s | 546 | 6.2% |
| u | 546 | 6.2% |
| f | 340 | 3.9% |
| t | 283 | 3.2% |
| Other values (7) | 1416 |
Country
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| United States |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Characters and Unicode
| Total characters | 12987 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 999 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 999 | |
| states | 999 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 2997 | |
| e | 1998 | |
| U | 999 | 7.7% |
| n | 999 | 7.7% |
| i | 999 | 7.7% |
| d | 999 | 7.7% |
| 999 | 7.7% | |
| S | 999 | 7.7% |
| a | 999 | 7.7% |
| s | 999 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 9990 | |
| Uppercase Letter | 1998 | 15.4% |
| Space Separator | 999 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 2997 | |
| e | 1998 | |
| n | 999 | 10.0% |
| i | 999 | 10.0% |
| d | 999 | 10.0% |
| a | 999 | 10.0% |
| s | 999 | 10.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 999 | |
| S | 999 |
Space Separator
| Value | Count | Frequency (%) |
| 999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11988 | |
| Common | 999 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 2997 | |
| e | 1998 | |
| U | 999 | 8.3% |
| n | 999 | 8.3% |
| i | 999 | 8.3% |
| d | 999 | 8.3% |
| S | 999 | 8.3% |
| a | 999 | 8.3% |
| s | 999 | 8.3% |
Common
| Value | Count | Frequency (%) |
| 999 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12987 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 2997 | |
| e | 1998 | |
| U | 999 | 7.7% |
| n | 999 | 7.7% |
| i | 999 | 7.7% |
| d | 999 | 7.7% |
| 999 | 7.7% | |
| S | 999 | 7.7% |
| a | 999 | 7.7% |
| s | 999 | 7.7% |
City
Text
| Distinct | 174 |
|---|---|
| Distinct (%) | 17.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 9.3373373 |
| Min length | 4 |
Characters and Unicode
| Total characters | 9328 |
|---|---|
| Distinct characters | 48 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 45 ? |
|---|---|
| Unique (%) | 4.5% |
Sample
| 1st row | Henderson |
|---|---|
| 2nd row | Henderson |
| 3rd row | Los Angeles |
| 4th row | Fort Lauderdale |
| 5th row | Fort Lauderdale |
| Value | Count | Frequency (%) |
| new | 109 | 7.6% |
| city | 107 | 7.5% |
| york | 100 | 7.0% |
| san | 88 | 6.1% |
| philadelphia | 71 | 4.9% |
| los | 62 | 4.3% |
| angeles | 62 | 4.3% |
| francisco | 60 | 4.2% |
| chicago | 35 | 2.4% |
| houston | 30 | 2.1% |
| Other values (190) | 712 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 840 | 9.0% |
| a | 763 | 8.2% |
| o | 731 | 7.8% |
| i | 664 | 7.1% |
| n | 630 | 6.8% |
| l | 564 | 6.0% |
| r | 496 | 5.3% |
| s | 455 | 4.9% |
| 437 | 4.7% | |
| t | 412 | 4.4% |
| Other values (38) | 3336 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7455 | |
| Uppercase Letter | 1436 | 15.4% |
| Space Separator | 437 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 840 | |
| a | 763 | |
| o | 731 | |
| i | 664 | |
| n | 630 | 8.5% |
| l | 564 | 7.6% |
| r | 496 | 6.7% |
| s | 455 | 6.1% |
| t | 412 | 5.5% |
| c | 269 | 3.6% |
| Other values (14) | 1631 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 220 | |
| S | 152 | |
| A | 123 | |
| N | 120 | |
| P | 111 | 7.7% |
| L | 106 | 7.4% |
| Y | 100 | 7.0% |
| F | 88 | 6.1% |
| D | 80 | 5.6% |
| M | 53 | 3.7% |
| Other values (13) | 283 |
Space Separator
| Value | Count | Frequency (%) |
| 437 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8891 | |
| Common | 437 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 840 | 9.4% |
| a | 763 | 8.6% |
| o | 731 | 8.2% |
| i | 664 | 7.5% |
| n | 630 | 7.1% |
| l | 564 | 6.3% |
| r | 496 | 5.6% |
| s | 455 | 5.1% |
| t | 412 | 4.6% |
| c | 269 | 3.0% |
| Other values (37) | 3067 |
Common
| Value | Count | Frequency (%) |
| 437 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 840 | 9.0% |
| a | 763 | 8.2% |
| o | 731 | 7.8% |
| i | 664 | 7.1% |
| n | 630 | 6.8% |
| l | 564 | 6.0% |
| r | 496 | 5.3% |
| s | 455 | 4.9% |
| 437 | 4.7% | |
| t | 412 | 4.4% |
| Other values (38) | 3336 |
State
Categorical
HIGH CORRELATION 
| Distinct | 40 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Pennsylvania | |
| Ohio | |
| Other values (35) |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 8.4394394 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8431 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | California |
| 4th row | Florida |
| 5th row | Florida |
Common Values
| Value | Count | Frequency (%) |
| California | 183 | |
| New York | 135 | |
| Texas | 92 | 9.2% |
| Pennsylvania | 79 | 7.9% |
| Ohio | 54 | 5.4% |
| Illinois | 52 | 5.2% |
| Florida | 42 | 4.2% |
| Michigan | 42 | 4.2% |
| Washington | 39 | 3.9% |
| Colorado | 35 | 3.5% |
| Other values (30) | 246 |
Length
| Value | Count | Frequency (%) |
| california | 183 | |
| new | 157 | |
| york | 135 | |
| texas | 92 | 7.8% |
| pennsylvania | 79 | 6.7% |
| ohio | 54 | 4.6% |
| illinois | 52 | 4.4% |
| florida | 42 | 3.6% |
| michigan | 42 | 3.6% |
| washington | 39 | 3.3% |
| Other values (33) | 307 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1023 | |
| i | 988 | |
| n | 819 | 9.7% |
| o | 766 | 9.1% |
| r | 537 | 6.4% |
| e | 498 | 5.9% |
| l | 485 | 5.8% |
| s | 424 | 5.0% |
| C | 248 | 2.9% |
| N | 184 | 2.2% |
| Other values (36) | 2459 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7066 | |
| Uppercase Letter | 1182 | 14.0% |
| Space Separator | 183 | 2.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1023 | |
| i | 988 | |
| n | 819 | |
| o | 766 | |
| r | 537 | |
| e | 498 | |
| l | 485 | |
| s | 424 | 6.0% |
| f | 183 | 2.6% |
| h | 181 | 2.6% |
| Other values (14) | 1162 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 248 | |
| N | 184 | |
| Y | 135 | |
| T | 102 | |
| M | 87 | 7.4% |
| P | 79 | 6.7% |
| I | 72 | 6.1% |
| O | 66 | 5.6% |
| W | 49 | 4.1% |
| F | 42 | 3.6% |
| Other values (11) | 118 |
Space Separator
| Value | Count | Frequency (%) |
| 183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8248 | |
| Common | 183 | 2.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1023 | |
| i | 988 | |
| n | 819 | 9.9% |
| o | 766 | 9.3% |
| r | 537 | 6.5% |
| e | 498 | 6.0% |
| l | 485 | 5.9% |
| s | 424 | 5.1% |
| C | 248 | 3.0% |
| N | 184 | 2.2% |
| Other values (35) | 2276 |
Common
| Value | Count | Frequency (%) |
| 183 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8431 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1023 | |
| i | 988 | |
| n | 819 | 9.7% |
| o | 766 | 9.1% |
| r | 537 | 6.4% |
| e | 498 | 5.9% |
| l | 485 | 5.8% |
| s | 424 | 5.0% |
| C | 248 | 2.9% |
| N | 184 | 2.2% |
| Other values (36) | 2459 |
Postal Code
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 221 |
|---|---|
| Distinct (%) | 22.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53511.934 |
| Minimum | 1841 |
|---|---|
| Maximum | 98661 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1841 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 19474 |
| median | 50315 |
| Q3 | 85023 |
| 95-th percentile | 95661 |
| Maximum | 98661 |
| Range | 96820 |
| Interquartile range (IQR) | 65549 |
Descriptive statistics
| Standard deviation | 31507.965 |
|---|---|
| Coefficient of variation (CV) | 0.58880259 |
| Kurtosis | -1.470991 |
| Mean | 53511.934 |
| Median Absolute Deviation (MAD) | 31172 |
| Skewness | -0.058412222 |
| Sum | 53458422 |
| Variance | 9.9275189 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 94110 | 32 | 3.2% |
| 10024 | 29 | 2.9% |
| 10035 | 28 | 2.8% |
| 10009 | 28 | 2.8% |
| 19140 | 28 | 2.8% |
| 43229 | 19 | 1.9% |
| 60610 | 17 | 1.7% |
| 94122 | 17 | 1.7% |
| 90032 | 16 | 1.6% |
| 19134 | 15 | 1.5% |
| Other values (211) | 770 |
| Value | Count | Frequency (%) |
| 1841 | 3 | |
| 1852 | 4 | |
| 2038 | 1 | 0.1% |
| 2886 | 2 | |
| 3301 | 4 | |
| 6040 | 4 | |
| 6360 | 1 | 0.1% |
| 6824 | 1 | 0.1% |
| 7036 | 1 | 0.1% |
| 7060 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 98661 | 3 | 0.3% |
| 98270 | 1 | 0.1% |
| 98198 | 2 | 0.2% |
| 98115 | 13 | |
| 98105 | 13 | |
| 98103 | 3 | 0.3% |
| 98026 | 4 | 0.4% |
| 97301 | 4 | 0.4% |
| 97206 | 5 | 0.5% |
| 95661 | 7 |
Region
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| East | |
|---|---|
| West | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8758759 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4871 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | South |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| East | 313 | |
| West | 301 | |
| Central | 245 | |
| South | 140 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| east | 313 | |
| west | 301 | |
| central | 245 | |
| south | 140 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 999 | |
| s | 614 | |
| a | 558 | |
| e | 546 | |
| E | 313 | 6.4% |
| W | 301 | 6.2% |
| C | 245 | 5.0% |
| n | 245 | 5.0% |
| r | 245 | 5.0% |
| l | 245 | 5.0% |
| Other values (4) | 560 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3872 | |
| Uppercase Letter | 999 | 20.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 999 | |
| s | 614 | |
| a | 558 | |
| e | 546 | |
| n | 245 | 6.3% |
| r | 245 | 6.3% |
| l | 245 | 6.3% |
| o | 140 | 3.6% |
| u | 140 | 3.6% |
| h | 140 | 3.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 313 | |
| W | 301 | |
| C | 245 | |
| S | 140 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4871 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 999 | |
| s | 614 | |
| a | 558 | |
| e | 546 | |
| E | 313 | 6.4% |
| W | 301 | 6.2% |
| C | 245 | 5.0% |
| n | 245 | 5.0% |
| r | 245 | 5.0% |
| l | 245 | 5.0% |
| Other values (4) | 560 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4871 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 999 | |
| s | 614 | |
| a | 558 | |
| e | 546 | |
| E | 313 | 6.4% |
| W | 301 | 6.2% |
| C | 245 | 5.0% |
| n | 245 | 5.0% |
| r | 245 | 5.0% |
| l | 245 | 5.0% |
| Other values (4) | 560 |
Category
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.811812 |
| Min length | 9 |
Characters and Unicode
| Total characters | 12799 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Furniture |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 603 | |
| Furniture | 206 | 20.6% |
| Technology | 190 | 19.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 603 | |
| supplies | 603 | |
| furniture | 206 | 12.9% |
| technology | 190 | 11.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1602 | |
| i | 1412 | |
| p | 1206 | |
| f | 1206 | |
| u | 1015 | 7.9% |
| c | 793 | 6.2% |
| l | 793 | 6.2% |
| O | 603 | 4.7% |
| s | 603 | 4.7% |
| S | 603 | 4.7% |
| Other values (10) | 2963 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 10594 | |
| Uppercase Letter | 1602 | 12.5% |
| Space Separator | 603 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1602 | |
| i | 1412 | |
| p | 1206 | |
| f | 1206 | |
| u | 1015 | |
| c | 793 | |
| l | 793 | |
| s | 603 | 5.7% |
| r | 412 | 3.9% |
| n | 396 | 3.7% |
| Other values (5) | 1156 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 603 | |
| S | 603 | |
| F | 206 | 12.9% |
| T | 190 | 11.9% |
Space Separator
| Value | Count | Frequency (%) |
| 603 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12196 | |
| Common | 603 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1602 | |
| i | 1412 | |
| p | 1206 | |
| f | 1206 | |
| u | 1015 | |
| c | 793 | 6.5% |
| l | 793 | 6.5% |
| O | 603 | 4.9% |
| s | 603 | 4.9% |
| S | 603 | 4.9% |
| Other values (9) | 2360 |
Common
| Value | Count | Frequency (%) |
| 603 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12799 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1602 | |
| i | 1412 | |
| p | 1206 | |
| f | 1206 | |
| u | 1015 | 7.9% |
| c | 793 | 6.2% |
| l | 793 | 6.2% |
| O | 603 | 4.7% |
| s | 603 | 4.7% |
| S | 603 | 4.7% |
| Other values (10) | 2963 |
Sub-Category
Categorical
HIGH CORRELATION 
| Distinct | 17 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Binders | |
|---|---|
| Paper | |
| Storage | |
| Furnishings | |
| Phones | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.2162162 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7209 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Labels |
| 4th row | Tables |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 145 | |
| Paper | 127 | |
| Storage | 95 | |
| Furnishings | 94 | |
| Phones | 88 | |
| Accessories | 83 | |
| Art | 81 | |
| Chairs | 58 | 5.8% |
| Appliances | 43 | 4.3% |
| Labels | 41 | 4.1% |
| Other values (7) | 144 |
Length
| Value | Count | Frequency (%) |
| binders | 145 | |
| paper | 127 | |
| storage | 95 | |
| furnishings | 94 | |
| phones | 88 | |
| accessories | 83 | |
| art | 81 | |
| chairs | 58 | 5.8% |
| appliances | 43 | 4.3% |
| labels | 41 | 4.1% |
| Other values (7) | 144 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 998 | |
| e | 900 | |
| r | 710 | 9.8% |
| i | 556 | 7.7% |
| n | 528 | 7.3% |
| a | 452 | 6.3% |
| o | 344 | 4.8% |
| p | 289 | 4.0% |
| h | 253 | 3.5% |
| c | 243 | 3.4% |
| Other values (18) | 1936 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6210 | |
| Uppercase Letter | 999 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 998 | |
| e | 900 | |
| r | 710 | |
| i | 556 | |
| n | 528 | |
| a | 452 | |
| o | 344 | 5.5% |
| p | 289 | 4.7% |
| h | 253 | 4.1% |
| c | 243 | 3.9% |
| Other values (8) | 937 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 215 | |
| A | 207 | |
| B | 166 | |
| F | 115 | |
| S | 115 | |
| C | 64 | 6.4% |
| L | 41 | 4.1% |
| T | 33 | 3.3% |
| E | 30 | 3.0% |
| M | 13 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7209 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 998 | |
| e | 900 | |
| r | 710 | 9.8% |
| i | 556 | 7.7% |
| n | 528 | 7.3% |
| a | 452 | 6.3% |
| o | 344 | 4.8% |
| p | 289 | 4.0% |
| h | 253 | 3.5% |
| c | 243 | 3.4% |
| Other values (18) | 1936 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 998 | |
| e | 900 | |
| r | 710 | 9.8% |
| i | 556 | 7.7% |
| n | 528 | 7.3% |
| a | 452 | 6.3% |
| o | 344 | 4.8% |
| p | 289 | 4.0% |
| h | 253 | 3.5% |
| c | 243 | 3.4% |
| Other values (18) | 1936 |
Sales
Real number (ℝ)
| Distinct | 907 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 241.339 |
| Minimum | 1.08 |
|---|---|
| Maximum | 8159.952 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1.08 |
|---|---|
| 5-th percentile | 4.8822 |
| Q1 | 18.364 |
| median | 55.98 |
| Q3 | 213.2975 |
| 95-th percentile | 1043.991 |
| Maximum | 8159.952 |
| Range | 8158.872 |
| Interquartile range (IQR) | 194.9335 |
Descriptive statistics
| Standard deviation | 596.14063 |
|---|---|
| Coefficient of variation (CV) | 2.470138 |
| Kurtosis | 76.85455 |
| Mean | 241.339 |
| Median Absolute Deviation (MAD) | 46.38 |
| Skewness | 7.3824622 |
| Sum | 241097.66 |
| Variance | 355383.65 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.96 | 8 | 0.8% |
| 15.552 | 6 | 0.6% |
| 14.62 | 4 | 0.4% |
| 32.4 | 4 | 0.4% |
| 24.56 | 4 | 0.4% |
| 8.82 | 3 | 0.3% |
| 18.28 | 3 | 0.3% |
| 242.94 | 3 | 0.3% |
| 1199.976 | 3 | 0.3% |
| 11.52 | 3 | 0.3% |
| Other values (897) | 958 |
| Value | Count | Frequency (%) |
| 1.08 | 1 | |
| 1.112 | 1 | |
| 1.248 | 1 | |
| 1.624 | 1 | |
| 1.68 | 1 | |
| 1.788 | 1 | |
| 2.08 | 1 | |
| 2.2 | 1 | |
| 2.308 | 1 | |
| 2.376 | 1 |
| Value | Count | Frequency (%) |
| 8159.952 | 1 | |
| 7999.98 | 1 | |
| 6354.95 | 1 | |
| 4355.168 | 1 | |
| 3991.98 | 1 | |
| 3347.37 | 1 | |
| 3083.43 | 1 | |
| 3059.982 | 2 | |
| 2999.95 | 1 | |
| 2735.952 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8008008 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2688443 |
|---|---|
| Coefficient of variation (CV) | 0.5969385 |
| Kurtosis | 2.1677722 |
| Mean | 3.8008008 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.328083 |
| Sum | 3797 |
| Variance | 5.1476547 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 248 | |
| 2 | 240 | |
| 4 | 122 | |
| 5 | 102 | |
| 1 | 90 | 9.0% |
| 7 | 67 | 6.7% |
| 6 | 58 | 5.8% |
| 8 | 32 | 3.2% |
| 9 | 21 | 2.1% |
| 10 | 7 | 0.7% |
| Other values (4) | 12 | 1.2% |
| Value | Count | Frequency (%) |
| 1 | 90 | 9.0% |
| 2 | 240 | |
| 3 | 248 | |
| 4 | 122 | |
| 5 | 102 | |
| 6 | 58 | 5.8% |
| 7 | 67 | 6.7% |
| 8 | 32 | 3.2% |
| 9 | 21 | 2.1% |
| 10 | 7 | 0.7% |
| Value | Count | Frequency (%) |
| 14 | 4 | 0.4% |
| 13 | 3 | 0.3% |
| 12 | 3 | 0.3% |
| 11 | 2 | 0.2% |
| 10 | 7 | 0.7% |
| 9 | 21 | 2.1% |
| 8 | 32 | 3.2% |
| 7 | 67 | |
| 6 | 58 | |
| 5 | 102 |
Discount
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16284284 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 462 |
| Zeros (%) | 46.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.2084592 |
|---|---|
| Coefficient of variation (CV) | 1.280125 |
| Kurtosis | 2.0549294 |
| Mean | 0.16284284 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.5959389 |
| Sum | 162.68 |
| Variance | 0.043455237 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 462 | |
| 0.2 | 380 | |
| 0.7 | 48 | 4.8% |
| 0.8 | 27 | 2.7% |
| 0.4 | 21 | 2.1% |
| 0.3 | 15 | 1.5% |
| 0.5 | 13 | 1.3% |
| 0.6 | 12 | 1.2% |
| 0.1 | 9 | 0.9% |
| 0.45 | 5 | 0.5% |
| Other values (2) | 7 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 462 | |
| 0.1 | 9 | 0.9% |
| 0.15 | 3 | 0.3% |
| 0.2 | 380 | |
| 0.3 | 15 | 1.5% |
| 0.32 | 4 | 0.4% |
| 0.4 | 21 | 2.1% |
| 0.45 | 5 | 0.5% |
| 0.5 | 13 | 1.3% |
| 0.6 | 12 | 1.2% |
| Value | Count | Frequency (%) |
| 0.8 | 27 | 2.7% |
| 0.7 | 48 | 4.8% |
| 0.6 | 12 | 1.2% |
| 0.5 | 13 | 1.3% |
| 0.45 | 5 | 0.5% |
| 0.4 | 21 | 2.1% |
| 0.32 | 4 | 0.4% |
| 0.3 | 15 | 1.5% |
| 0.2 | 380 | |
| 0.15 | 3 | 0.3% |
Profit
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 940 |
|---|---|
| Distinct (%) | 94.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.752018 |
| Minimum | -3839.9904 |
|---|---|
| Maximum | 3177.475 |
| Zeros | 6 |
| Zeros (%) | 0.6% |
| Negative | 186 |
| Negative (%) | 18.6% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | -3839.9904 |
|---|---|
| 5-th percentile | -102.8922 |
| Q1 | 1.80245 |
| median | 8.694 |
| Q3 | 27.3175 |
| 95-th percentile | 140.94495 |
| Maximum | 3177.475 |
| Range | 7017.4654 |
| Interquartile range (IQR) | 25.51505 |
Descriptive statistics
| Standard deviation | 225.7271 |
|---|---|
| Coefficient of variation (CV) | 12.037483 |
| Kurtosis | 137.46563 |
| Mean | 18.752018 |
| Median Absolute Deviation (MAD) | 10.5248 |
| Skewness | -1.6471439 |
| Sum | 18733.266 |
| Variance | 50952.724 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.2208 | 7 | 0.7% |
| 0 | 6 | 0.6% |
| 5.4432 | 5 | 0.5% |
| 6.8714 | 4 | 0.4% |
| 15.552 | 4 | 0.4% |
| 9.936 | 3 | 0.3% |
| 2.9568 | 2 | 0.2% |
| 2.8536 | 2 | 0.2% |
| 6.8768 | 2 | 0.2% |
| 26.6304 | 2 | 0.2% |
| Other values (930) | 962 |
| Value | Count | Frequency (%) |
| -3839.9904 | 1 | |
| -1665.0522 | 1 | |
| -1359.992 | 1 | |
| -950.4 | 1 | |
| -814.4832 | 1 | |
| -760.98 | 1 | |
| -619.596 | 1 | |
| -509.997 | 1 | |
| -453.849 | 1 | |
| -407.976 | 1 |
| Value | Count | Frequency (%) |
| 3177.475 | 1 | |
| 1995.99 | 1 | |
| 1415.4296 | 1 | |
| 1379.977 | 1 | |
| 1276.4871 | 1 | |
| 829.3754 | 1 | |
| 701.9883 | 1 | |
| 679.996 | 1 | |
| 636.0003 | 1 | |
| 601.9699 | 1 |
| Category | Discount | Postal Code | Profit | Quantity | Region | Row ID | Sales | Segment | State | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | -0.058 | 0.025 | 0.142 | -0.003 | 0.000 | 0.014 | -0.003 | 0.000 | 0.049 | 0.993 |
| Discount | -0.058 | 1.000 | 0.052 | -0.515 | 0.034 | 0.261 | -0.068 | 0.013 | 0.000 | 0.322 | 0.364 |
| Postal Code | 0.025 | 0.052 | 1.000 | 0.013 | 0.000 | 0.924 | -0.087 | 0.031 | 0.136 | 0.955 | 0.064 |
| Profit | 0.142 | -0.515 | 0.013 | 1.000 | 0.257 | 0.062 | 0.074 | 0.470 | 0.041 | 0.104 | 0.277 |
| Quantity | -0.003 | 0.034 | 0.000 | 0.257 | 1.000 | 0.032 | -0.058 | 0.374 | 0.000 | 0.000 | 0.000 |
| Region | 0.000 | 0.261 | 0.924 | 0.062 | 0.032 | 1.000 | 0.032 | 0.043 | 0.079 | 0.982 | 0.104 |
| Row ID | 0.014 | -0.068 | -0.087 | 0.074 | -0.058 | 0.032 | 1.000 | -0.024 | 0.120 | 0.230 | 0.000 |
| Sales | -0.003 | 0.013 | 0.031 | 0.470 | 0.374 | 0.043 | -0.024 | 1.000 | 0.000 | 0.034 | 0.246 |
| Segment | 0.000 | 0.000 | 0.136 | 0.041 | 0.000 | 0.079 | 0.120 | 0.000 | 1.000 | 0.243 | 0.000 |
| State | 0.049 | 0.322 | 0.955 | 0.104 | 0.000 | 0.982 | 0.230 | 0.034 | 0.243 | 1.000 | 0.031 |
| Sub-Category | 0.993 | 0.364 | 0.064 | 0.277 | 0.000 | 0.104 | 0.000 | 0.246 | 0.000 | 0.031 | 1.000 |
| Row ID | Segment | Country | City | State | Postal Code | Region | Category | Sub-Category | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | Consumer | United States | Henderson | Kentucky | 42420 | South | Furniture | Bookcases | 261.9600 | 2 | 0.00 | 41.9136 |
| 1 | 2 | Consumer | United States | Henderson | Kentucky | 42420 | South | Furniture | Chairs | 731.9400 | 3 | 0.00 | 219.5820 |
| 2 | 3 | Corporate | United States | Los Angeles | California | 90036 | West | Office Supplies | Labels | 14.6200 | 2 | 0.00 | 6.8714 |
| 3 | 4 | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | Furniture | Tables | 957.5775 | 5 | 0.45 | -383.0310 |
| 4 | 5 | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | Office Supplies | Storage | 22.3680 | 2 | 0.20 | 2.5164 |
| 5 | 6 | Consumer | United States | Los Angeles | California | 90032 | West | Furniture | Furnishings | 48.8600 | 7 | 0.00 | 14.1694 |
| 6 | 7 | Consumer | United States | Los Angeles | California | 90032 | West | Office Supplies | Art | 7.2800 | 4 | 0.00 | 1.9656 |
| 7 | 8 | Consumer | United States | Los Angeles | California | 90032 | West | Technology | Phones | 907.1520 | 6 | 0.20 | 90.7152 |
| 8 | 9 | Consumer | United States | Los Angeles | California | 90032 | West | Office Supplies | Binders | 18.5040 | 3 | 0.20 | 5.7825 |
| 9 | 10 | Consumer | United States | Los Angeles | California | 90032 | West | Office Supplies | Appliances | 114.9000 | 5 | 0.00 | 34.4700 |
| Row ID | Segment | Country | City | State | Postal Code | Region | Category | Sub-Category | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 989 | 990 | Corporate | United States | Auburn | New York | 13021 | East | Office Supplies | Art | 17.970 | 3 | 0.0 | 5.2113 |
| 990 | 991 | Home Office | United States | Jacksonville | Florida | 32216 | South | Furniture | Chairs | 1166.920 | 5 | 0.2 | 131.2785 |
| 991 | 992 | Consumer | United States | New York City | New York | 10024 | East | Office Supplies | Binders | 14.624 | 2 | 0.2 | 5.4840 |
| 992 | 993 | Consumer | United States | San Jose | California | 95123 | West | Office Supplies | Fasteners | 10.230 | 3 | 0.0 | 4.9104 |
| 993 | 994 | Consumer | United States | San Jose | California | 95123 | West | Office Supplies | Paper | 154.900 | 5 | 0.0 | 69.7050 |
| 994 | 995 | Corporate | United States | Virginia Beach | Virginia | 23464 | South | Office Supplies | Binders | 2715.930 | 7 | 0.0 | 1276.4871 |
| 995 | 996 | Corporate | United States | Virginia Beach | Virginia | 23464 | South | Technology | Phones | 617.970 | 3 | 0.0 | 173.0316 |
| 996 | 997 | Consumer | United States | Henderson | Kentucky | 42420 | South | Office Supplies | Envelopes | 10.670 | 1 | 0.0 | 4.9082 |
| 997 | 998 | Consumer | United States | Henderson | Kentucky | 42420 | South | Office Supplies | Storage | 36.630 | 3 | 0.0 | 9.8901 |
| 998 | 999 | Consumer | United States | Henderson | Kentucky | 42420 | South | Furniture | Furnishings | 24.100 | 5 | 0.0 | 9.1580 |